package com.watcloud.plugin.impl.kingbase;

import com.alibaba.nacos.plugin.datasource.mapper.ConfigInfoAggrMapper;
import com.watcloud.plugin.constants.DataSourceConstant;

public class ConfigInfoAggrMapperByKingbase extends KingbaseAbstractMapper implements ConfigInfoAggrMapper {

	@Override
	public String findConfigInfoAggrByPageFetchRows(int startRow, int pageSize) {
		String sql = "SELECT data_id,group_id,tenant_id,datum_id,app_name,content FROM config_info_aggr WHERE data_id= ? AND "
				+ "group_id= ? AND tenant_id= ? ORDER BY datum_id LIMIT " + startRow + "," + pageSize;
		return sql;
	}

	@Override
	public String getDataSource() {
		return DataSourceConstant.KINGBASE;
	}

}
